|
DETAILED SYLLABUS DCSP
DCSP - 1 COMPUTER SCIENCE AND OPERATING SYSTEMS (WINDOWS AND LINUX)
1. INTRODUCTION What is a Computer?, Purpose of using a computer, Why it is used (characteristics of computer), Instruction, Program
2. TYPES OF COMPUTER Analog, Digital, and Hybrid type, Hardware, Software, System software, Application software, Firm ware, Human ware, Stored Program Concept, Evolution of computers, Generation of computer.
3. NUMBER SYSTEMS Decimal system, Binary system, Use of binary system in digital computers, Conversion of binary to decimal and decimal to binary, Hexadecimal system and its interconversion, Alpha numeric codes-ASCII & EBCDIC
4. PROGRAMMING LANGUAGES Machine language, Assembly language, High level language
5. ORGANIZATION OF A DIGITAL COMPUTER Input unit, Output unit, Central Processing unit, Memory
6. DATA PROCESSING Data collection, Classification, Sorting and Merging, Processing, Summarising, Storing
7. DATA ORGANIZATION Organization of Data, Character, Field, Record, File, Database, Sequential Access, Random Access, Indexed Sequential Access
8. PROGRAMMING PROCESS Problem Definition, Algorithm, Flowchart and coding, Testing and debugging, Implementation, Documentation, Structured Programming
9. DATA COMMUNICATION Local Area Network, Wide Area Network, Satellite Communication, Internet
10. OPERATING SYSTEM Introduction, Different Operating Systems, Loading and Quitting the Operating Systems, Important DOS Commands
WINDOWS
1. WINDOWS INTRODUCTION Operating System
2. Desk top icons My Computer, Recycle Bin, Internet Explorer, Network Neighborhood, My Documents
3. Working with windows How to create a Folder, Copying and cutting files, Renaming
4. START ICON Programs, Favorites, Documents, Settings, Find, Run, Shut down
5. APPLICATION ICONS
LINUX 1. HISTORY 2. DISTRIBUTIONS 3. DEVICES AND DRIVES IN LINUX 4. FILE SYSTEM HIERARCHY 5. COMPONENTS: KERNEL, DISTRIBUTION, SAWFISH, GNOME.
DCSP - 2 personal computer software tools (ms word, EXCEL AND powerpoint)
MS WORD
1. AN INTRODUCTION TO WORD The Word workspace, Starting and quitting Word, Creating and Manipulating Various documents, Editing of proofing files, Merging documents and macros
2. HOW TO USE MOUSE AND MENU Working with dialog box
3. PRIMARY COMMANDS IN FILE MENU The Open Commands, The File menu commands, The New commands, The save , Save As, and Save all commands, The Close command, The page setup, The Print commands, The Exit commands,
4. EDIT MENU COMMANDS The Cut, Copy, and Paste commands, The Undo and Repeat commands 5. FORMAT COMMANDS Font commands, Paragraph commands
6. OTHER MENU The view menu, The Insert menu, The tool menu, The table menu, The Window menu
EXCEL
1. BUILDING A SIMPLE WORKSHEET Entering Text, Entering Values, Entering Dates and Times, Moving Around, Selecting Ranges, Using Menu, Using Tool Bar, Using Shortcut Menus, Changing entries, Copying entries, Moving Entries, Inserting and Deleting cells
2. FORMATTING BASICS Changing Character Style, Changing Alignment, Changing Column Width
3. WORKING WITH MULTIPLE WORKSHEET Copying entries between work books, Moving sheets between work books, Deleting sheets, Quitting Excel
4. OPENING EXISTING WORKBOOKS Simple calculations, Doing Arithmetic, Totaling column of values, Naming cells and Ranges
5. FORMATTING TEXT Displaying dollars and cents, Formatting decimal places, Formatting dates, Copying style and formats
6. FORMULAS THAT MAKE DECISIONS Using the IF function, Using the nested IF function, Copying formulas
7. Checking Spelling, Printing Worksheets, Preview Worksheets, Setting up the pages
8. Sorting data, Keeping Leading in View, Finding records, Adding and deleting Records, Filtering Records
9. Plotting charts, Sizing and moving charts, Updating charts, Changing the chart type, Using chart auto format,
10. Creating Macros, Recording Macros, Running Macros
Power Point
1. POWER POINT Main Features of Power Point
2. Making the Presentation Creating Template with the Auto Content Wizard. Creating a Presentation with a Template. Creating a presentation from Scratch
3 Different Views Normal Slide, Outline, Slide Sorter, Slide Show, Notes, Slide Master
4 Animation, Art and Sound Controlling Transitions between slides. Animating Different Parts of a slide. Inserting a Motion Clip. Including Sounds in slides.
5. Including Graphs, Charts, Tables and Columns Organization Chart Slide, Creating a table Slide. Creating two column Slide, Module 1: Showing A Presentation, Rehearsing/ Timing a Presentation, Designation some slides as “Hidden”, Viewing Slides Anywhere in a Slide Show.
6. Techniques for Making a Show Livelier
7. Office Connections Presenting with the help of other Office Programs Importing the text from a World Document.
8. PRINTING A PRESENTATION
DCSP - 3 office procedures and various devices used in modern office
1. OFFICE What is an office?, Nature of office work, Need for office automation, What is office automation, Information technology : trends and economics
2. OFFICE VIEWS Analytical perspective, Interpretation, System Analysis, Office System Development, Office Models Information Control Net based Models, Petri Net Based Model, Form Flow Model Office procedure Automation System (OPAS) 3 OFFICE METHODOLOGIES Office analysis Methodologies (OMA), Office Analysis and Diagnostic Methodology (OADM)
4 DOCUMENT PREPARATION Type writer, Word Processor, Word Processing Packages, Choosing a word processor, Laser printer Plain paper copies, Intelligent copier/printer, Other Office equipment for document preparation, Dictation and transcription equipment, Mechanized shorthand recorder, Duplicating equipment, The mimeograph duplicator, The direct image offset duplicator, Paper shredder, Desk Top Publishing
5 DOCUMENT STORAGE AND RETRIEVAL Microform document systems Roll microfilm system, Microfiche system, Ultrafiche system, Scroll system, Video micrographic system Optical Storage Systems Optical Storage System CD-ROM Application, Scanners, Optical tape, Optical Card, Multimedia document storage system, Office document architecture
6. COMMUNICATION SYSTEM Communication Basics The media, Modulation, Demodulation, Bandwidth, Communication line type, Synchronous/Asynchronous transmission, Communication protocol, Communication LAN connection Wide Area Networks Communication services Electronic Mail, Facsimile Transmission, Teletext, Teleconferencing Voice Systems Voice Message mail system, Touch Tone Telephone, Computer based Telephones, EPABX, Integrated voice data terminals (IVDT)
7 INTEGRATED OFFICE SYSTEMS Integrated Office systems, Work station Office Automation Organization and Management Office Technology – Introduction, Responsibility, Managing the change, The organization The management structure Control within organization, The role of middle managers, Informal factors Organizing office works Commercial integrated office systems, Professional office systems (PROFS), ALL-IN-1, How to manage innovations in the office,The strategic frame work, Benefits of office automation, DCSP - 4 INTERNET applications
1. INTRODUCTION TO INTERNET Understanding Networks, Getting to know web browsers, Getting to know the Internet Explorer Window
2. APPLICATIONS Internet Electronic Mail, Setting up E-mail, Creating Mail Messages, Editing Mail Messages, Attaching a file to a Mail message, Sending and receiving mail messages, Creating and using an Address Book
3. SEARCHING AND BROWSING ON THE INTERNET Internet Searching, Tools for Specialized Searches, Finding Specific Topics
DCSP - 5 microsoft office- lab
DCSP - 6 project
| ||||||||||||||||||||||||